package com.example.ksnacosprovider.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import pojo.Customer;
import tools.Page;

import java.util.List;

@Mapper
public interface CustomerMapper {
    //增加客户信息
    public boolean InsertCustomer(Customer customer);

    //删除客户信息
    public boolean DelCustomer(int id);

    //修改客户信息
    public boolean UpdateCustomer(Customer customer);

    //分页查询客户信息
    public List<Customer> SelCustomer(@Param("customerNumber") String customerNumber,@Param("customerName") String customerName,@Param("page") Page page);

    //查看总条数
    public int SelectTotle(@Param("customerNumber") String customerNumber,@Param("customerName") String customerName);
}
